package com.usian.springbootmysql.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.usian.springbootmysql.dao.CollegeDao;
import com.usian.springbootmysql.pojo.ResultVo;
import com.usian.springbootmysql.pojo.SearchDto;
import com.usian.springbootmysql.pojo.TbCollege;
import com.usian.springbootmysql.service.CollegeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils;

import java.util.List;

@Service
public class CollegeServiceImpl extends ServiceImpl<CollegeDao, TbCollege> implements CollegeService {

    @Autowired
    private CollegeDao collegeDao;

    @Override
    public ResultVo saveCollege(TbCollege tbCollege) {

//        QueryWrapper<TbCollege> query = new QueryWrapper<TbCollege>();
//        query.eq("name",tbCollege.getName());

        LambdaQueryWrapper<TbCollege> lambdaQueryWrapper = new LambdaQueryWrapper<TbCollege>();
        lambdaQueryWrapper.eq(TbCollege::getName, tbCollege.getName());
        int count = collegeDao.selectCount(lambdaQueryWrapper);

        if (count > 0) {
            return new ResultVo(201, "名称存在，不允许添加", null);
        } else {
            collegeDao.insert(tbCollege);
            return new ResultVo(200, "添加成功", null);
        }
    }

    @Override
    public List<TbCollege> search(int status) {
        LambdaQueryWrapper<TbCollege> query = new LambdaQueryWrapper<TbCollege>();
        query.eq(TbCollege::getStatus, status);
        List<TbCollege> list = collegeDao.selectList(query);
        return list;
    }

    @Override
    public List<TbCollege> searchvo(TbCollege tbCollege) {
        LambdaQueryWrapper<TbCollege> query = new LambdaQueryWrapper<TbCollege>();
        if (!StringUtils.isEmpty(tbCollege.getName())) {
            query.like(TbCollege::getName, tbCollege.getName());
        }
        if (tbCollege.getStatus() != null) {
            query.eq(TbCollege::getStatus, tbCollege.getStatus());
        }
        List<TbCollege> list = collegeDao.selectList(query);
        return list;
    }

    @Override
    public IPage<TbCollege> searchPage(SearchDto searchDto) {
        Page<TbCollege> page = new Page<>(searchDto.getPage(), searchDto.getSize());
        LambdaQueryWrapper<TbCollege> query = new LambdaQueryWrapper<TbCollege>();
        if (!StringUtils.isEmpty(searchDto.getName())){
            query.like(TbCollege::getName,searchDto.getName());
        }
        if (searchDto.getStatus()!=null){
            query.eq(TbCollege::getStatus,searchDto.getStatus());
        }
        IPage<TbCollege> list = collegeDao.selectPage(page,query);
        return list;
    }


}
